﻿CREATE TABLE [dbo].[admin_RoleInMenu] (
    [IDMeniuAplicatie] INT              NOT NULL,
    [RoleId]           UNIQUEIDENTIFIER NOT NULL,
    [TipAccess]        VARCHAR (50)     NOT NULL,
    CONSTRAINT [PK_admin_RoleInMenu] PRIMARY KEY CLUSTERED ([IDMeniuAplicatie] ASC, [RoleId] ASC),
    CONSTRAINT [FK_admin_RoleInMenu_admin_ApplicationMenu] FOREIGN KEY ([IDMeniuAplicatie]) REFERENCES [dbo].[admin_ApplicationMenu] ([IDMeniuAplicatie]),
    CONSTRAINT [FK_admin_RoleInMenu_aspnet_Roles] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[aspnet_Roles] ([RoleId])
);

